In [14]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

from plotly import __version__
from plotly.offline import download_plotlyjs, init_notebook_mode, plot, iplot

import plotly.plotly as py
import plotly.graph_objs as go
import seaborn as sns

import cufflinks as cf
init_notebook_mode(connected=True)
cf.go_offline()
In [6]:
path_av = './AviationData.xlsx'
path_df = './df.xlsx'
In [7]:
df_av = pd.read_excel(path_av)
df_df = pd.read_excel(path_df)
In [8]:
df_av.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 81366 entries, 0 to 81365
Data columns (total 31 columns):
Event Id                  81366 non-null object
Type                      81366 non-null object
Accident #                81366 non-null object
Event Date                81366 non-null object
Location                  81366 non-null object
Country                   81366 non-null object
Latitude                  81366 non-null object
Longitude                 81366 non-null object
Airport Code              81366 non-null object
Airport Name              81366 non-null object
Injury Severity           81366 non-null object
Aircraft Damage           81366 non-null object
Aircraft Category         81366 non-null object
Registration Number       81366 non-null object
Make                      81366 non-null object
Model                     81366 non-null object
Amateur Built             81366 non-null object
Number of Engines         81366 non-null object
Engine Type               81366 non-null object
FAR Description           81366 non-null object
Schedule                  81366 non-null object
Purpose of Flight         81366 non-null object
Air Carrier               81366 non-null object
Total Fatal Injuries      81366 non-null object
Total Serious Injuries    81366 non-null object
Total Minor Injuries      81366 non-null object
Total Uninjured           81366 non-null object
Weather Condition         81366 non-null object
Broad Phase of Flight     81366 non-null object
Report Status             81366 non-null object
Publication Date          81366 non-null object
dtypes: object(31)
memory usage: 9.6+ MB
In [9]:
df_df.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 81366 entries, 0 to 81365
Data columns (total 47 columns):
Country                                80859 non-null object
Type                                   81366 non-null int64
Amateur Built                          80749 non-null float64
Number of Engines                      81366 non-null int64
Injury Severity                        81366 non-null int64
Report_Factual                         81366 non-null int64
Report_Foreign                         81366 non-null int64
Report_Preliminary                     81366 non-null int64
Report_Probable Cause                  81366 non-null int64
Purpose_Aerial Application             81366 non-null int64
Purpose_Aerial Observation             81366 non-null int64
Purpose_Air Drop                       81366 non-null int64
Purpose_Air Race/Show                  81366 non-null int64
Purpose_Banner Tow                     81366 non-null int64
Purpose_Business                       81366 non-null int64
Purpose_Executive/Corporate            81366 non-null int64
Purpose_External Load                  81366 non-null int64
Purpose_Ferry                          81366 non-null int64
Purpose_Firefighting                   81366 non-null int64
Purpose_Flight Test                    81366 non-null int64
Purpose_Glider Tow                     81366 non-null int64
Purpose_Instructional                  81366 non-null int64
Purpose_Other Work Use                 81366 non-null int64
Purpose_Personal                       81366 non-null int64
Purpose_Positioning                    81366 non-null int64
Purpose_Public Aircraft                81366 non-null int64
Purpose_Public Aircraft - Federal      81366 non-null int64
Purpose_Public Aircraft - Local        81366 non-null int64
Purpose_Public Aircraft - State        81366 non-null int64
Purpose_Skydiving                      81366 non-null int64
Purpose_Unknown                        81366 non-null int64
Damage_Destroyed                       81366 non-null int64
Damage_Minor                           81366 non-null int64
Damage_Substantial                     81366 non-null int64
Aircraft Category_Airplane             81366 non-null int64
Aircraft Category_Balloon              81366 non-null int64
Aircraft Category_Blimp                81366 non-null int64
Aircraft Category_Glider               81366 non-null int64
Aircraft Category_Gyrocraft            81366 non-null int64
Aircraft Category_Gyroplane            81366 non-null int64
Aircraft Category_Helicopter           81366 non-null int64
Aircraft Category_Powered Parachute    81366 non-null int64
Aircraft Category_Powered-Lift         81366 non-null int64
Aircraft Category_Rocket               81366 non-null int64
Aircraft Category_Ultralight           81366 non-null int64
Aircraft Category_Unknown              81366 non-null int64
Aircraft Category_Weight-Shift         81366 non-null int64
dtypes: float64(1), int64(45), object(1)
memory usage: 29.5+ MB
In [15]:
corr = df_df.corr()
plt.figure(figsize=(30,20)) #To adjust the size of graph
sns.heatmap(corr, linewidths=2, fmt=".2f", annot=True) #Use to show values in the boxes
Out[15]:
<matplotlib.axes._subplots.AxesSubplot at 0x10d49e50>

Correlations from the above graph

  1. Injury severity is maximum when aircraft gets destroyed and minimum when aircraft has minimal damage.
  2. Injuries is directly depended on the damage caused to the aircraft.
  3. Report Foreign has second maximum correlation that means that most fatalities not in homeground.
  4. Fatalities are minimum when injuries are reported as a probable cause
In [16]:
df_df[['Injury Severity']].iplot(kind="hist", bins=2)
In [19]:
fatal_df = df_av[(df_av['Injury Severity']==' Fatal ')]
In [20]:
fatal_df
Out[20]:
Event Id Type Accident # Event Date Location Country Latitude Longitude Airport Code Airport Name ... Purpose of Flight Air Carrier Total Fatal Injuries Total Serious Injuries Total Minor Injuries Total Uninjured Weather Condition Broad Phase of Flight Report Status Publication Date
6 20180331X84022 Accident WPR18FA116 03/31/2018 Santa Paula, CA United States 34.3453 -119.047 SZP SANTA PAULA ... Personal 2 VMC APPROACH Preliminary 04/05/2018
20 20180327X91612 Accident WPR18LA113 03/27/2018 Stockton, CA United States 37.8478 -121.516 N/A ... Aerial Application 1 VMC MANEUVERING Preliminary 04/04/2018
22 20180326X54912 Accident WPR18FA112 03/26/2018 Marina, CA United States 36.6756 -121.757 OAR Marina Municipal Airport ... Personal 1 VMC TAKEOFF Preliminary 04/04/2018
32 20180323X80643 Accident CEN18FA126 03/21/2018 Pierce, NE United States 42.2386 -97.5972 Private ... Personal 1 VMC APPROACH Preliminary 03/29/2018
55 20180312X03110 Accident WPR18FA104 03/11/2018 La Center, WA United States ... Personal 1 MANEUVERING Preliminary 04/05/2018
59 20180311X13013 Accident ERA18MA099 03/11/2018 New York, NY United States 40.7736 -73.9394 N/A ... Aerial Observation 5 1 VMC STANDING Preliminary 03/23/2018
71 20180308X30039 Accident CEN18FA116 03/08/2018 Laredo, TX United States KLRD ... Personal 2 VMC LANDING Preliminary 03/12/2018
80 20180305X44855 Accident ERA18LA095 03/05/2018 Beaufort, SC United States 32.4122 -80.6344 ARW Beaufort County Airport ... Personal 1 VMC TAKEOFF Preliminary 03/26/2018
92 20180304X41553 Accident ERA18LA094 02/28/2018 Ocean City, MD United States 38.2881 -75.0919 OXB OCEAN CITY MUNI ... Personal 2 VMC DESCENT Preliminary 03/15/2018
94 20180227X14047 Accident ERA18FA092 02/27/2018 Georgetown, FL United States 29.4306 -81.6764 3FL0 MOUNT ROYAL ... Personal 2 VMC APPROACH Preliminary 03/05/2018
96 20180226X95618 Accident ERA18FA088 02/26/2018 Greenwood, MS United States 33.5067 -90.27 N/A ... Aerial Application 1 VMC MANEUVERING Preliminary 03/16/2018
101 20180225X92244 Accident ERA18LA089 02/25/2018 Eustis, FL United States 28.8433 -81.63 X55 MID FLORIDA AIR SERVICE ... Personal 1 VMC APPROACH Preliminary 03/14/2018
107 20180223X23016 Accident WPR18FA095 02/22/2018 Monticello, UT United States 37.7817 -109.173 N/A ... Personal 4 UNKNOWN Preliminary 03/08/2018
108 20180223X04505 Accident CEN18FA108 02/22/2018 Ulysses, KS United States 37.6528 -101.371 ... Personal 2 VMC CLIMB Preliminary 02/28/2018
109 20180222X31345 Accident CEN18FA107 02/22/2018 Rossville, IN United States 40.4647 -86.6128 N/A ... Business 3 IMC CLIMB Preliminary 03/05/2018
111 20180221X04610 Accident WPR18FA093 02/21/2018 San Diego, CA United States 32.8189 -117.123 MYF Montgomery-Gibbs Executive Air ... Personal 1 VMC TAKEOFF Preliminary 02/26/2018
114 20180221X93251 Accident ERA18FA084 02/21/2018 Bonifay, FL United States 30 -85 1J0 TRI-COUNTY ... Flight Test 1 VMC APPROACH Preliminary 02/27/2018
117 20180220X11813 Accident WPR18FA091 02/19/2018 Minden, NV United States 39.0497 -119.794 ... Personal 1 VMC DESCENT Preliminary 03/06/2018
121 20180218X81015 Accident CEN18FA101 02/18/2018 Evanston, WY United States 41.2881 -110.982 EVW EVANSTON-UINTA COUNTY BURNS FI ... Personal 2 IMC APPROACH Preliminary 02/27/2018
124 20180220X92338 Accident CEN18WA103 02/17/2018 Saint Laurent La Roche, France France ... 3 CRUISE Foreign
136 20180301X24451 Accident CEN18WA110 02/12/2018 El Pozo, Mexico Mexico 24.9178 -107.251 N/A ... 2 UNKNOWN Foreign
137 20180213X20952 Accident ANC18FA024 02/12/2018 Chuckanut, WA United States 48.655 -122.465 N/A ... Personal 1 VMC Preliminary 02/26/2018
139 20180211X53503 Accident WPR18FA088 02/11/2018 AGUA DULCE, CA United States 34.4547 -118.301 N/A ... Personal 4 VMC Preliminary 02/26/2018
142 20180321X15750 Accident DCA18WA107 02/11/2018 Argunovo, Russia Russia ... 71 TAKEOFF Foreign
143 20180212X10716 Accident CEN18WA096 02/11/2018 Helle, Norway Norway 68.2433 14.6692 ... 2 TAKEOFF Foreign
144 20180210X14603 Accident WPR18FA087 02/10/2018 Peach Springs, AZ United States 35.9672 -113.769 N/A ... Papillon Airways, Inc. 3 4 VMC MANEUVERING Preliminary 02/20/2018
148 20180316X41258 Accident ERA18WA108 02/09/2018 Ribeirao Cascalheira, Brazil Brazil -12.6 -51.3833 N/A ... Aerial Application 1 MANEUVERING Foreign
154 20180222X30131 Accident ERA18WA085 02/07/2018 Itaituba, Brazil Brazil -6.82361 -56.8456 N/A ... 3 UNKNOWN Foreign
156 20180206X32714 Accident WPR18FA084 02/06/2018 Santee, CA United States 32.8167 -116.983 SEE GILLESPIE FIELD ... Personal 2 IMC TAKEOFF Preliminary 03/06/2018
162 20180205X40240 Accident ERA18LA083 02/05/2018 Carrabelle, FL United States 29.8419 -84.7011 X13 CARRABELLE-THOMPSON ... Personal 1 VMC TAKEOFF Preliminary 02/08/2018
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
81261 20020917X02142 Accident FTW82FRG21 01/17/1982 PORT MANSFIELD, TX United States T05 PORT MANSFIELD ... Unknown 1 0 0 0 VMC APPROACH Probable Cause 01/17/1983
81264 20020917X01721 Accident ATL82FA035 01/17/1982 PICAYUNE, MS United States PCU PICAYUNE-PEARL RIVER CNTY ... Unknown 2 0 0 0 VMC TAKEOFF Probable Cause 01/17/1983
81269 20020917X02096 Accident FTW82FA041 01/16/1982 HOUMA, LA United States ... Unknown OFFSHORE LOGISTICS 1 2 0 0 IMC CRUISE Probable Cause 01/16/1983
81275 20020917X01966 Accident DEN82FA018 01/15/1982 28 MI ENE OGDEN, UT United States ... Personal 3 0 0 0 VMC CLIMB Probable Cause 01/15/1983
81282 20020917X01907 Accident DCA82AA011 01/13/1982 WASHINGTON, DC United States WASHINGTON NATIONAL ... Unknown AIR FLORIDA, INC 78 6 3 0 IMC TAKEOFF Probable Cause 01/13/1983
81289 20020917X01965 Accident DEN82FA017 01/11/1982 RIVERTON, WY United States RIVERTON REGIONAL ... Personal 4 1 1 0 IMC TAKEOFF Probable Cause 01/11/1983
81296 20020917X01719 Accident ATL82FA032 01/10/1982 HENDERSON, NC United States ... Personal 1 1 0 0 VMC CRUISE Probable Cause 01/10/1983
81307 20020917X02414 Accident MIA82FLD14 01/08/1982 ODESSA, FL United States X41 W. PASCO ... Personal 1 0 0 0 IMC APPROACH Probable Cause 01/08/1983
81308 20020917X01881 Accident CHI82FA024 01/08/1982 NEW PHILADELPHI, OH United States PHO HARRY CLEVER FIELD ... Personal 1 1 0 0 VMC APPROACH Probable Cause 01/08/1983
81313 20020917X01964 Accident DEN82FA016 01/07/1982 HELENA, MT United States ... Unknown ROBERT R. HYLTON 2 0 0 0 VMC CRUISE Probable Cause 01/07/1983
81321 20020917X02304 Accident LAX82FUM06 01/05/1982 RAMONA, CA United States L39 RAMONA ... Business 3 0 0 0 IMC CRUISE Probable Cause 01/05/1983
81322 20020917X02253 Accident LAX82FA036 01/05/1982 BLACK CANYON CI, AZ United States ... Personal 1 0 0 0 IMC CRUISE Probable Cause 01/05/1983
81325 20020917X01906 Accident DCA82AA009 01/05/1982 ITHACA, NY United States TOMPKINS COUNTY ... Unknown EMPIRE AIRLINES 2 0 0 0 VMC APPROACH Probable Cause 01/05/1983
81329 20020917X02618 Accident SEA82FA015 01/04/1982 PLEASANT HILL, OR United States ... Personal 4 0 0 0 VMC CRUISE Probable Cause 01/04/1983
81330 20020917X02410 Accident MIA82FKA05 01/04/1982 SAINT CROIX STX ALEXANDER HAMILTON ... Business 1 0 1 0 VMC TAXI Probable Cause 01/04/1983
81331 20020917X02254 Accident LAX82FA038 01/04/1982 NEAR LAS VEGAS, NV United States ... Unknown LANG AIR SERVICE 2 0 0 0 VMC CRUISE Probable Cause 01/04/1983
81333 20020917X01880 Accident CHI82FA019 01/04/1982 FORT WAYNE, IN United States ... Personal 2 2 0 0 IMC CRUISE Probable Cause 01/04/1983
81337 20020917X02255 Accident LAX82FA040 01/03/1982 10 NM W LEE VIN, CA United States ... Personal 2 1 0 0 IMC DESCENT Probable Cause 01/03/1983
81341 20020917X01905 Accident DCA82AA008 01/03/1982 ASHLAND, VA United States HANOVER COUNTY ... Business 8 0 0 0 IMC APPROACH Probable Cause 01/03/1983
81342 20020917X01720 Accident ATL82FA033 01/03/1982 PINEHURST, NC United States SOP MOORE COUNTY ... Personal 1 0 0 0 IMC APPROACH Probable Cause 01/03/1983
81346 20020917X02134 Accident FTW82FRA14 01/02/1982 HEARNE, TX United States T72 HEARNE MUNICIPAL ... Personal 1 0 0 0 IMC TAKEOFF Probable Cause 01/02/1983
81347 20020917X02119 Accident FTW82FPJ10 01/02/1982 CHICKASHA, OK United States ... Personal 1 0 0 0 IMC CRUISE Probable Cause 01/02/1983
81348 20020917X02117 Accident FTW82FPG08 01/02/1982 LITTLE ROCK, AR United States ... Personal 2 0 0 0 IMC CRUISE Probable Cause 01/02/1983
81353 20020917X01656 Accident ANC82FAG14 01/02/1982 SKWENTA, AK United States ... Personal 3 0 0 0 VMC UNKNOWN Probable Cause 01/02/1983
81359 20001218X45446 Accident CHI81LA106 08/01/1981 COTTON, MN United States ... Personal 4 0 0 0 IMC UNKNOWN Probable Cause 11/06/2001
81361 20041105X01764 Accident CHI79FA064 08/02/1979 Canton, OH United States ... Personal 1 2 VMC APPROACH Probable Cause 04/16/1980
81362 20001218X45448 Accident LAX96LA321 06/19/1977 EUREKA, CA United States ... Personal 2 0 0 0 IMC CRUISE Probable Cause 09/12/2000
81363 20061025X01555 Accident NYC07LA005 08/30/1974 Saltville, VA United States 36.9222 -81.8781 ... Personal 3 IMC CRUISE Probable Cause 02/26/2007
81364 20001218X45447 Accident LAX94LA336 07/19/1962 BRIDGEPORT, CA United States ... Personal 4 0 0 0 UNK UNKNOWN Probable Cause 09/19/1996
81365 20001218X45444 Accident SEA87LA080 10/24/1948 MOOSE CREEK, ID United States ... Personal 2 0 0 0 UNK CRUISE Probable Cause

16291 rows × 31 columns

In [21]:
fatal_df[['Aircraft Category']].iplot(kind='hist')
In [27]:
fatal_df[['Purpose of Flight']].iplot(kind='hist')

Most fatalities are caused in private aircrafts used for personal use

In [28]:
fatal_df[['Country']].iplot(kind='hist')
  1. Most Fatalities are reported in USA
  2. 39 Reported in India out of which 5 are from Mumbai and 1 Fatal from Juhu airports
  3. 23 Reported from Pakistan
In [29]:
def fatalAutoGraphs(name):
    fatal = df_av[(df_av['Injury Severity']==' Fatal ')]
    return fatal[[name]].iplot(kind='hist')
In [32]:
fatalAutoGraphs('Aircraft Damage')
In [31]:
def nonFatalAutoGraphs(name):
    non_fatal = df_av[(df_av['Injury Severity']==' Non-Fatal ')]
    return non_fatal[[name]].iplot(kind='hist')
In [33]:
nonFatalAutoGraphs('Aircraft Damage')

Non fatal injuries are highest when aircraft damage is substantial

In [40]:
df_av
Out[40]:
Event Id Type Accident # Event Date Location Country Latitude Longitude Airport Code Airport Name ... Purpose of Flight Air Carrier Total Fatal Injuries Total Serious Injuries Total Minor Injuries Total Uninjured Weather Condition Broad Phase of Flight Report Status Publication Date
0 20180410X65647 Accident GAA18CA206 04/10/2018 Edgewood, NM United States 35.0947 -106.164 1N1 SANDIA AIRPARK ESTATES EAST ... Personal 1 VMC Preliminary 04/10/2018
1 20180410X72014 Accident GAA18CA209 04/09/2018 Lake Tahoe, CA United States 38.8939 -119.995 TVL LAKE TAHOE ... Instructional 1 VMC Preliminary 04/10/2018
2 20180406X70836 Accident GAA18CA203 04/06/2018 Caldwell, ID United States 43.6419 -116.636 EUL CALDWELL INDUSTRIAL ... Personal 2 VMC Preliminary 04/10/2018
3 20180409X53403 Accident GAA18CA205 04/05/2018 Vernon, TX United States 34.2253 -99.2831 F05 WILBARGER COUNTY ... Personal 1 Preliminary 04/10/2018
4 20180402X73754 Accident GAA18CA196 04/01/2018 Seldovia, AK United States 59.4422 -151.704 SOV SELDOVIA ... Instructional 2 Preliminary 04/03/2018
5 20180401X75919 Accident GAA18CA193 04/01/2018 Phoenix, AZ United States 33.6889 -112.082 DVT PHOENIX DEER VALLEY ... Instructional 2 VMC Preliminary 04/03/2018
6 20180331X84022 Accident WPR18FA116 03/31/2018 Santa Paula, CA United States 34.3453 -119.047 SZP SANTA PAULA ... Personal 2 VMC APPROACH Preliminary 04/05/2018
7 20180405X31138 Accident GAA18CA202 03/31/2018 Nephi, UT United States 39.7353 -111.87 U14 NEPHI MUNI ... 1 Preliminary 04/06/2018
8 20180331X52951 Accident GAA18CA192 03/31/2018 Prescott, AZ United States 34.65 -112.427 PRC ERNEST A LOVE FIELD ... Instructional 2 Preliminary 04/02/2018
9 20180331X05529 Accident CEN18LA131 03/31/2018 Grove, OK United States N/A ... Personal 1 1 VMC Preliminary 04/03/2018
10 20180330X51628 Accident GAA18CA191 03/30/2018 Dorris, CA United States 41.8903 -121.976 A32 BUTTE VALLEY ... Personal 1 VMC Preliminary 04/09/2018
11 20180330X95108 Accident GAA18CA190 03/30/2018 Salina, CA United States 36.6631 -121.608 SNS SALINAS MUNI ... 1 Preliminary 04/02/2018
12 20180330X34903 Accident GAA18CA189 03/30/2018 Gila Bend, AZ United States 32.9589 -112.679 E63 GILA BEND MUNI ... Instructional 1 VMC Preliminary 04/02/2018
13 20180330X63516 Accident GAA18CA188 03/30/2018 Nampa, ID United States 43.5833 -116.523 MAN NAMPA MUNI ... Personal 1 Preliminary 04/02/2018
14 20180404X35211 Accident GAA18CA200 03/29/2018 Lantana, FL United States 26.5931 -80.085 LNA PALM BEACH COUNTY PARK ... Personal 1 VMC Preliminary 04/10/2018
15 20180404X24706 Accident GAA18CA199 03/29/2018 New Bedford, MA United States 41.6769 -70.9586 EWB NEW BEDFORD RGNL ... Instructional 1 Preliminary 04/04/2018
16 20180329X95659 Accident GAA18CA187 03/29/2018 King Salmon, AK United States 58.6797 -156.656 AKN KING SALMON ... LAKE CLARK AIR INC 8 IMC Preliminary 04/09/2018
17 20180329X20254 Accident GAA18CA186 03/29/2018 Silver Bay, MN United States 47.2492 -91.4156 BFW SILVER BAY MUNI ... Personal 1 VMC Preliminary 03/29/2018
18 20180328X44355 Accident GAA18CA185 03/28/2018 Cave Creek, AZ United States ... 13 Preliminary 03/29/2018
19 20180328X04527 Accident ERA18LA117 03/28/2018 Sebring, FL United States 27.4625 -81.3447 SEF Sebring Regional Airport ... Personal 3 VMC TAXI Preliminary 04/06/2018
20 20180327X91612 Accident WPR18LA113 03/27/2018 Stockton, CA United States 37.8478 -121.516 N/A ... Aerial Application 1 VMC MANEUVERING Preliminary 04/04/2018
21 20180327X95733 Accident GAA18CA183 03/27/2018 Fullerton, CA United States 33.8719 -117.98 FUL FULLERTON MUNI ... Personal 1 VMC Preliminary 03/28/2018
22 20180326X54912 Accident WPR18FA112 03/26/2018 Marina, CA United States 36.6756 -121.757 OAR Marina Municipal Airport ... Personal 1 VMC TAKEOFF Preliminary 04/04/2018
23 20180326X21650 Accident GAA18CA179 03/26/2018 Haverhill, NH United States 5B9 ... Personal 1 Preliminary 03/27/2018
24 20180326X24908 Accident CEN18LA127 03/25/2018 Fulton, TX United States 28.1542 -96.9758 9TE5 Kalt Ranch Airport ... Personal 1 VMC Preliminary 03/29/2018
25 20180323X13524 Accident GAA18CA178 03/23/2018 Hartselle, AL United States 34.4072 -86.9331 5M0 HARTSELLE-MORGAN COUNTY REGION ... Personal 1 VMC Preliminary 03/28/2018
26 20180323X23446 Accident GAA18CA175 03/23/2018 Beaver Falls, PA United States 40.7725 -80.3869 BVI BEAVER COUNTY ... Instructional 1 VMC Preliminary 03/28/2018
27 20180323X42038 Accident ERA18LA115 03/23/2018 Canton, MS United States 32.6225 -90.1031 N/A ... Personal 1 VMC LANDING Preliminary 04/06/2018
28 20180327X15528 Accident CEN18LA128 03/22/2018 Kansas City, MO United States 39.1231 -94.5928 MKC Downtown Air ... Personal 2 VMC LANDING Preliminary 04/02/2018
29 20180319X90457 Accident CEN18LA123 03/22/2018 Dewitt, MI United States 42.8875 -84.7169 ... Personal 1 VMC APPROACH Preliminary 03/26/2018
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
81336 20020917X02333 Incident LAX82IA034 01/03/1982 VAN NUYS, CA United States VNY VAN NUYS ... Personal 0 0 0 1 VMC APPROACH Probable Cause 01/03/1983
81337 20020917X02255 Accident LAX82FA040 01/03/1982 10 NM W LEE VIN, CA United States ... Personal 2 1 0 0 IMC DESCENT Probable Cause 01/03/1983
81338 20020917X02155 Accident LAX82DA035 01/03/1982 SAN CLEMENTINE, CA United States ... Personal 0 0 2 0 VMC MANEUVERING Probable Cause 01/03/1983
81339 20020917X01992 Accident FTW82DA036 01/03/1982 FORT WORTH, TX United States OAK GROVE ... Personal 0 0 2 0 VMC APPROACH Probable Cause 01/03/1983
81340 20020917X01960 Accident DEN82DTI09 01/03/1982 GREENOUGH, MT United States ... Ferry 0 0 0 1 VMC TAKEOFF Probable Cause 01/03/1983
81341 20020917X01905 Accident DCA82AA008 01/03/1982 ASHLAND, VA United States HANOVER COUNTY ... Business 8 0 0 0 IMC APPROACH Probable Cause 01/03/1983
81342 20020917X01720 Accident ATL82FA033 01/03/1982 PINEHURST, NC United States SOP MOORE COUNTY ... Personal 1 0 0 0 IMC APPROACH Probable Cause 01/03/1983
81343 20020917X02481 Accident NYC82DA016 01/02/1982 GALETON, PA United States 5G6 CHERRY SPRINGS ... Personal 0 0 0 1 VMC TAXI Probable Cause 01/02/1983
81344 20020917X02339 Accident MIA82DA028 01/02/1982 MIAMI, FL United States ... Personal 0 0 0 2 VMC CRUISE Probable Cause 01/02/1983
81345 20020917X02148 Accident FTW82FRJ07 01/02/1982 HOMER, LA United States ... Personal 0 0 1 0 IMC CRUISE Probable Cause 01/02/1983
81346 20020917X02134 Accident FTW82FRA14 01/02/1982 HEARNE, TX United States T72 HEARNE MUNICIPAL ... Personal 1 0 0 0 IMC TAKEOFF Probable Cause 01/02/1983
81347 20020917X02119 Accident FTW82FPJ10 01/02/1982 CHICKASHA, OK United States ... Personal 1 0 0 0 IMC CRUISE Probable Cause 01/02/1983
81348 20020917X02117 Accident FTW82FPG08 01/02/1982 LITTLE ROCK, AR United States ... Personal 2 0 0 0 IMC CRUISE Probable Cause 01/02/1983
81349 20020917X01962 Accident DEN82DTM08 01/02/1982 MIDWAY, UT United States FIELD RANCH ... Personal 0 0 0 1 IMC TAXI Probable Cause 01/02/1983
81350 20020917X01894 Accident CHI82FEC08 01/02/1982 YPSILANTI, MI United States YIP WILLOW RUN ... Instructional 0 0 0 1 VMC TAKEOFF Probable Cause 01/02/1983
81351 20020917X01776 Accident CHI82DA020 01/02/1982 CHARLOTTE, MI United States 49G TINKERBELL ... Personal 0 0 0 2 VMC APPROACH Probable Cause 01/02/1983
81352 20020917X01657 Accident ATL82DA027 01/02/1982 CHAMBLEE, GA United States PDK ... Unknown ROCKY MOUNTAIN HELICOPTERS, IN 0 0 0 1 VMC APPROACH Probable Cause 01/02/1983
81353 20020917X01656 Accident ANC82FAG14 01/02/1982 SKWENTA, AK United States ... Personal 3 0 0 0 VMC UNKNOWN Probable Cause 01/02/1983
81354 20020909X01562 Accident SEA82DA022 01/01/1982 PULLMAN, WA United States BLACKBURN AG STRIP ... Personal 0 0 0 2 VMC TAKEOFF Probable Cause 01/01/1982
81355 20020909X01561 Accident NYC82DA015 01/01/1982 EAST HANOVER, NJ United States N58 HANOVER ... Business 0 0 0 2 IMC LANDING Probable Cause 01/01/1982
81356 20020909X01560 Accident MIA82DA029 01/01/1982 JACKSONVILLE, FL United States JAX JACKSONVILLE INTL ... Personal 0 0 3 0 IMC CRUISE Probable Cause 01/01/1982
81357 20020909X01559 Accident FTW82DA034 01/01/1982 HOBBS, NM United States ... Personal 0 0 0 1 VMC APPROACH Probable Cause 01/01/1982
81358 20020909X01558 Accident ATL82DKJ10 01/01/1982 TUSKEGEE, AL United States TUSKEGEE ... Personal 0 0 0 1 VMC LANDING Probable Cause 01/01/1982
81359 20001218X45446 Accident CHI81LA106 08/01/1981 COTTON, MN United States ... Personal 4 0 0 0 IMC UNKNOWN Probable Cause 11/06/2001
81360 20170710X52551 Accident NYC79AA106 09/17/1979 Boston, MA United States 42.4453 -70.7583 N/A ... Air Canada 1 44 VMC CLIMB Probable Cause 09/19/2017
81361 20041105X01764 Accident CHI79FA064 08/02/1979 Canton, OH United States ... Personal 1 2 VMC APPROACH Probable Cause 04/16/1980
81362 20001218X45448 Accident LAX96LA321 06/19/1977 EUREKA, CA United States ... Personal 2 0 0 0 IMC CRUISE Probable Cause 09/12/2000
81363 20061025X01555 Accident NYC07LA005 08/30/1974 Saltville, VA United States 36.9222 -81.8781 ... Personal 3 IMC CRUISE Probable Cause 02/26/2007
81364 20001218X45447 Accident LAX94LA336 07/19/1962 BRIDGEPORT, CA United States ... Personal 4 0 0 0 UNK UNKNOWN Probable Cause 09/19/1996
81365 20001218X45444 Accident SEA87LA080 10/24/1948 MOOSE CREEK, ID United States ... Personal 2 0 0 0 UNK CRUISE Probable Cause

81366 rows × 31 columns

In [44]:
df_av['Latitude'].replace('  ', np.nan, inplace=True)
df_av['Longitude'].replace('  ', np.nan, inplace=True)
df_av['Airport Name'].replace('  ', np.nan, inplace=True)

df_av.dropna(subset=['Latitude'], inplace=True)
df_av.dropna(subset=['Longitude'], inplace=True)
df_av.dropna(subset=['Airport Name'], inplace=True)

df_av
Out[44]:
Event Id Type Accident # Event Date Location Country Latitude Longitude Airport Code Airport Name ... Purpose of Flight Air Carrier Total Fatal Injuries Total Serious Injuries Total Minor Injuries Total Uninjured Weather Condition Broad Phase of Flight Report Status Publication Date
0 20180410X65647 Accident GAA18CA206 04/10/2018 Edgewood, NM United States 35.094722 -106.164444 1N1 SANDIA AIRPARK ESTATES EAST ... Personal 1 VMC Preliminary 04/10/2018
1 20180410X72014 Accident GAA18CA209 04/09/2018 Lake Tahoe, CA United States 38.893889 -119.995277 TVL LAKE TAHOE ... Instructional 1 VMC Preliminary 04/10/2018
2 20180406X70836 Accident GAA18CA203 04/06/2018 Caldwell, ID United States 43.641944 -116.635833 EUL CALDWELL INDUSTRIAL ... Personal 2 VMC Preliminary 04/10/2018
3 20180409X53403 Accident GAA18CA205 04/05/2018 Vernon, TX United States 34.225278 -99.283056 F05 WILBARGER COUNTY ... Personal 1 Preliminary 04/10/2018
4 20180402X73754 Accident GAA18CA196 04/01/2018 Seldovia, AK United States 59.442222 -151.703889 SOV SELDOVIA ... Instructional 2 Preliminary 04/03/2018
5 20180401X75919 Accident GAA18CA193 04/01/2018 Phoenix, AZ United States 33.688889 -112.081945 DVT PHOENIX DEER VALLEY ... Instructional 2 VMC Preliminary 04/03/2018
6 20180331X84022 Accident WPR18FA116 03/31/2018 Santa Paula, CA United States 34.345277 -119.047500 SZP SANTA PAULA ... Personal 2 VMC APPROACH Preliminary 04/05/2018
7 20180405X31138 Accident GAA18CA202 03/31/2018 Nephi, UT United States 39.735277 -111.870000 U14 NEPHI MUNI ... 1 Preliminary 04/06/2018
8 20180331X52951 Accident GAA18CA192 03/31/2018 Prescott, AZ United States 34.650000 -112.427500 PRC ERNEST A LOVE FIELD ... Instructional 2 Preliminary 04/02/2018
10 20180330X51628 Accident GAA18CA191 03/30/2018 Dorris, CA United States 41.890277 -121.975556 A32 BUTTE VALLEY ... Personal 1 VMC Preliminary 04/09/2018
11 20180330X95108 Accident GAA18CA190 03/30/2018 Salina, CA United States 36.663056 -121.607778 SNS SALINAS MUNI ... 1 Preliminary 04/02/2018
12 20180330X34903 Accident GAA18CA189 03/30/2018 Gila Bend, AZ United States 32.958889 -112.679445 E63 GILA BEND MUNI ... Instructional 1 VMC Preliminary 04/02/2018
13 20180330X63516 Accident GAA18CA188 03/30/2018 Nampa, ID United States 43.583333 -116.523334 MAN NAMPA MUNI ... Personal 1 Preliminary 04/02/2018
14 20180404X35211 Accident GAA18CA200 03/29/2018 Lantana, FL United States 26.593055 -80.085000 LNA PALM BEACH COUNTY PARK ... Personal 1 VMC Preliminary 04/10/2018
15 20180404X24706 Accident GAA18CA199 03/29/2018 New Bedford, MA United States 41.676945 -70.958611 EWB NEW BEDFORD RGNL ... Instructional 1 Preliminary 04/04/2018
16 20180329X95659 Accident GAA18CA187 03/29/2018 King Salmon, AK United States 58.679723 -156.656111 AKN KING SALMON ... LAKE CLARK AIR INC 8 IMC Preliminary 04/09/2018
17 20180329X20254 Accident GAA18CA186 03/29/2018 Silver Bay, MN United States 47.249166 -91.415556 BFW SILVER BAY MUNI ... Personal 1 VMC Preliminary 03/29/2018
19 20180328X04527 Accident ERA18LA117 03/28/2018 Sebring, FL United States 27.462500 -81.344722 SEF Sebring Regional Airport ... Personal 3 VMC TAXI Preliminary 04/06/2018
20 20180327X91612 Accident WPR18LA113 03/27/2018 Stockton, CA United States 37.847777 -121.516111 N/A ... Aerial Application 1 VMC MANEUVERING Preliminary 04/04/2018
21 20180327X95733 Accident GAA18CA183 03/27/2018 Fullerton, CA United States 33.871945 -117.979723 FUL FULLERTON MUNI ... Personal 1 VMC Preliminary 03/28/2018
22 20180326X54912 Accident WPR18FA112 03/26/2018 Marina, CA United States 36.675556 -121.756944 OAR Marina Municipal Airport ... Personal 1 VMC TAKEOFF Preliminary 04/04/2018
24 20180326X24908 Accident CEN18LA127 03/25/2018 Fulton, TX United States 28.154167 -96.975834 9TE5 Kalt Ranch Airport ... Personal 1 VMC Preliminary 03/29/2018
25 20180323X13524 Accident GAA18CA178 03/23/2018 Hartselle, AL United States 34.407222 -86.933056 5M0 HARTSELLE-MORGAN COUNTY REGION ... Personal 1 VMC Preliminary 03/28/2018
26 20180323X23446 Accident GAA18CA175 03/23/2018 Beaver Falls, PA United States 40.772500 -80.386944 BVI BEAVER COUNTY ... Instructional 1 VMC Preliminary 03/28/2018
27 20180323X42038 Accident ERA18LA115 03/23/2018 Canton, MS United States 32.622500 -90.103056 N/A ... Personal 1 VMC LANDING Preliminary 04/06/2018
28 20180327X15528 Accident CEN18LA128 03/22/2018 Kansas City, MO United States 39.123056 -94.592777 MKC Downtown Air ... Personal 2 VMC LANDING Preliminary 04/02/2018
30 20180402X10600 Accident GAA18CA195 03/21/2018 Knox, IN United States 41.325556 -86.662222 OXI STARKE COUNTY ... Instructional 2 VMC Preliminary 04/09/2018
31 20180322X14941 Accident CEN18LA125 03/21/2018 Beggs, OK United States 35.793611 -96.029723 51OK Eagle Creek ... Personal 1 1 VMC TAKEOFF Preliminary 03/26/2018
32 20180323X80643 Accident CEN18FA126 03/21/2018 Pierce, NE United States 42.238611 -97.597222 Private ... Personal 1 VMC APPROACH Preliminary 03/29/2018
33 20180323X80752 Accident WPR18LA111 03/20/2018 Clatskanie, OR United States 46.155000 123.237500 N/A ... Personal 1 VMC Preliminary 04/04/2018
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
33210 20001212X20849 Accident LAX00LA149 04/11/2000 FRESNO, CA United States 36.776111 -119.719167 FAT Fresno Airport ... Instructional 0 0 0 1 VMC TAKEOFF Probable Cause 12/06/2002
33211 20001212X20834 Accident LAX00FA151 04/11/2000 Fullerton, CA United States 33.866667 -117.966667 FUL Fullerton Municipal ... Personal 1 0 0 0 VMC TAKEOFF Probable Cause 04/15/2003
33236 20001212X20873 Accident MIA00FA129 04/05/2000 MARIANNA, FL United States 1.483333 -75.533333 MAI MARIANNA MUNI ... Instructional 3 VMC APPROACH Probable Cause 01/25/2011
33245 20001212X20830 Accident IAD00LA031 04/03/2000 SELINSGROVE, PA United States 40.820556 -76.863889 SEG Selinsgrove ... Personal 0 0 0 1 VMC GO-AROUND Probable Cause 09/30/2003
33302 20001212X20689 Accident MIA00FA118 03/26/2000 Panama City, FL United States 30.227778 -85.719723 KPFN Panama City-Bay County Int'l ... Personal 1 0 0 0 IMC DESCENT Probable Cause 04/15/2003
33319 20001212X20660 Accident LAX00FA134 03/24/2000 RIALTO, CA United States 34.118056 -117.383611 L67 Rialto Municipal ... Instructional 1 0 0 0 VMC APPROACH Probable Cause 11/25/2003
33338 20001212X20624 Accident FTW00FA101 03/21/2000 KILLEEN, TX United States 31.085833 -97.686389 ILE Killeen Municipal ... American Eagle Airlines, Inc. (DBA: American ... 0 0 1 35 IMC LANDING Probable Cause 06/03/2002
33379 20001212X20664 Incident LAX00IA127 03/13/2000 SAN FRANCISCO, CA United States 37.620278 -122.380000 SFO SAN FRANCISCO INTL ... Unknown DELTA AIRLINES, INC. 0 0 0 77 VMC TAKEOFF Probable Cause 10/31/2006
33391 20001212X20658 Accident LAX00FA126 03/11/2000 Fallbrook, CA United States 33.354167 -117.250833 L18 Fallbrook Community Airpark ... Personal 1 1 0 0 VMC TAKEOFF Probable Cause 11/25/2003
33405 20001212X20669 Accident LAX00LA118 03/08/2000 CALIPATRIA, CA United States 33.130000 -115.521667 CLR Cliff Hatfield Memorial ... Aerial Application 1 VMC TAKEOFF Probable Cause 12/06/2002
33417 20001212X20573 Incident ANC00IA034 03/07/2000 FAIRBANKS, AK United States 64.800000 -147.866111 FAI Fairbanks International ... ALASKA AIR GROUP (DBA: ALASKA AIRLINES) 0 0 0 117 VMC TAKEOFF Probable Cause 07/01/2002
33435 20030721X01158 Accident ATL00LA031 03/03/2000 Manatee, FL United States 27.485277 -82.534166 Redder Airport ... Personal 1 VMC APPROACH Probable Cause 09/30/2003
33475 20001212X20507 Incident LAX00IA106 02/21/2000 FRESNO, CA United States 36.575000 -119.091666 KFAT Fresno-Yosemite International ... Unknown 0 0 0 20 VMC CRUISE Probable Cause 04/28/2004
33490 20030819X01362 Accident NYC00LA083 02/18/2000 SANDUSKY, OH United States 41.433333 -82.652222 SKY GRIFFIN SANDUSKY ... Positioning 1 VMC LANDING Probable Cause 11/25/2003
33506 20001212X20505 Accident LAX00FA101B 02/15/2000 Palm Springs, CA United States 33.833333 -116.516667 PSP Palm Springs International ... Instructional 3 2 VMC APPROACH Probable Cause 11/25/2003
33507 20001212X20505 Accident LAX00FA101A 02/15/2000 Palm Springs, CA United States 33.833333 -116.516667 PSP Palm Springs International ... Instructional 3 2 VMC APPROACH Probable Cause 11/25/2003
33534 20001212X20536 Accident MIA00LA091 02/09/2000 MONROE, GA United States 33.782500 -83.692777 D73 Monroe-Walton County ... Business 0 0 0 1 VMC TAXI Probable Cause 09/30/2003
33617 20001212X20356 Accident FTW00FA070 01/22/2000 San Antonio, TX United States 29.553611 -98.483056 SAT San Antonio International ... Personal 2 VMC TAKEOFF Probable Cause 06/04/2002
33633 20001212X20391 Accident LAX00LA076 01/18/2000 BRAWLEY, CA United States 32.000000 -115.000000 N/A ... Aerial Application 0 0 1 0 VMC MANEUVERING Probable Cause 12/06/2002
33678 20001212X20387 Accident LAX00LA071 01/04/2000 CHANDLER, AZ United States 33.266667 -111.800000 Memorial ... Instructional 0 0 0 2 VMC APPROACH Probable Cause 11/25/2003
35075 20001212X19017 Accident LAX99FA218B 06/06/1999 LOS ANGELES, CA United States 33.938611 -118.408889 LAX Los Angeles International ... Unknown 699 VMC STANDING Probable Cause 11/25/2003
35076 20001212X19017 Accident LAX99FA218A 06/06/1999 LOS ANGELES, CA United States 33.938611 -118.408889 LAX Los Angeles International ... Unknown PHILIPPINE AIRLINES, INC. 699 VMC TAXI Probable Cause 11/25/2003
35777 20001205X00119 Incident ANC99IA027 02/05/1999 FAIRBANKS, AK United States 64.800000 -147.866111 FAI Fairbanks International ... ALASKA AIR GROUP, INC (DBA: ALASKA AIRLINES) 0 0 0 138 IMC TAKEOFF Probable Cause 07/01/2002
35960 20001211X11573 Accident LAX99FA051 12/17/1998 Los Angeles, CA United States 33.948611 -118.413611 LAX Los Angeles International ... Unknown Clay Lacy (DBA: Clay Lacy Aviation) 0 0 0 7 VMC CRUISE Probable Cause 11/25/2003
36165 20041203X01907 Accident ATL99FA136 11/04/1998 Robbinsville, NC United States 35.389722 -83.920556 K6A3 Andrews-Murphy ... Personal 1 IMC CRUISE Probable Cause 12/28/2006
36498 20001211X11043 Accident FTW98FA380 09/11/1998 Houston, TX United States 29.607222 -95.158611 EFD Ellington Field ... 0 0 0 2 IMC APPROACH Probable Cause 02/26/2007
42623 20011127X02295 Accident NYC96FA192 11/28/1995 Marlinton, WV United States 38.335000 -80.280000 48I Braxton County ... Positioning 1 IMC CRUISE Probable Cause 01/16/2003
50002 20170710X10920 Accident FTW92FA224 09/05/1992 Alpine, TX United States 30.383611 -103.783334 N/A ... Personal 1 1 VMC UNKNOWN Probable Cause 09/19/2017
80772 20080417X00504 Accident MIA08CA076 03/16/1982 Mobile, AL United States 30.757778 -88.355555 MOB MOBILE REGIONAL ... Unknown 1 IMC LANDING Probable Cause 04/30/2008
81360 20170710X52551 Accident NYC79AA106 09/17/1979 Boston, MA United States 42.445277 -70.758333 N/A ... Air Canada 1 44 VMC CLIMB Probable Cause 09/19/2017

20663 rows × 31 columns

In [50]:
mapbox_access_token = 'pk.eyJ1IjoibmFuYXdhcmV0IiwiYSI6ImNqZnlkOHpwaTVvcjgzMHBvdW55c2lzcHIifQ.PiO1zMvZi1UHjwXl5FcIbg'

data = Data([
    Scattermapbox(
        lat=df_av['Latitude'].tolist(),
        lon=df_av['Longitude'].tolist(),
        mode='markers',
        marker=Marker(
            size=3
        ),
        text=df_av['Airport Name'].tolist(),
    )
])
layout = Layout(
    autosize=True,
    hovermode='closest',
    mapbox=dict(
        accesstoken=mapbox_access_token,
        bearing=0,
        center=dict(
            lat=0,
            lon=0
        ),
        pitch=0,
        zoom=0
    ),
)

fig = dict(data=data, layout=layout)
py.iplot(fig, filename='Multiple Mapbox')
Out[50]: